RetailRocket ์ถ”์ฒœ ์‹œ์Šคํ…œ EDA ๋ฆฌํฌํŠธ

๋ชฉํ‘œ: ์‚ฌ์šฉ์ž ํ–‰๋™ ๊ธฐ๋ฐ˜ ์ƒํ’ˆ ์ถ”์ฒœ ์‹œ์Šคํ…œ ๊ตฌ์ถ•์„ ์œ„ํ•œ ๋ฐ์ดํ„ฐ ๋ถ„์„
ํ•ต์‹ฌ ๊ธฐ๋Šฅ: ํด๋ฆญ/์žฅ๋ฐ”๊ตฌ๋‹ˆ/๊ตฌ๋งค ์ด๋ ฅ์„ ๊ธฐ๋ฐ˜์œผ๋กœ ํ•œ ๋น„์Šทํ•œ ์ œํ’ˆ ์ถ”์ฒœ

๐Ÿ“Š 1. ๋ฐ์ดํ„ฐ ๊ธฐ๋ณธ ๊ตฌ์กฐ

2,756,101
events ํ–‰ ์ˆ˜
20,275,902
item_properties ํ–‰ ์ˆ˜
1,669
category_tree ํ–‰ ์ˆ˜

๐Ÿ‘ฅ 2. ์‚ฌ์šฉ์ž ํ–‰๋™ ํŒจํ„ด ๋ถ„์„

๐Ÿ‘ค ์‚ฌ์šฉ์ž ์œ ํ˜• ๋ถ„ํฌ

buyer: 11,719๋ช… (0.83%)
1,407,580
์ด ์‚ฌ์šฉ์ž
1,236,032
์นดํ…Œ๊ณ ๋ฆฌ ์„ ํ˜ธ๋„ ๋ณด์œ  ์‚ฌ์šฉ์ž

๐ŸŽฏ 3. ์•„์ดํ…œ ์œ ์‚ฌ๋„ ํŠน์„ฑ ๋ถ„์„

449,240
๋ถ„์„๋œ ์•„์ดํ…œ ์ˆ˜
399,425
์นดํ…Œ๊ณ ๋ฆฌ ์ •๋ณด ๋ณด์œ  ์•„์ดํ…œ

๐Ÿ† ์ƒ์œ„ ์ธ๊ธฐ ์•„์ดํ…œ (Top 10)

์•„์ดํ…œ ID์ธ๊ธฐ๋„ ์ ์ˆ˜์ „ํ™˜์œจ (%)์นดํ…Œ๊ณ ๋ฆฌ
461686 4787.0 5.24 1037.0
187946 3416.0 0.00 1393.0
5411 2352.0 0.00 789.0
7943 2097.0 3.42 398.0
320130 2086.0 2.48 707.0
320130 2086.0 2.48 707.0
320130 2086.0 2.48 707.0
320130 2086.0 2.48 707.0
320130 2086.0 2.48 707.0
320130 2086.0 2.48 707.0

๐Ÿ“Š 4. ์„ธ์…˜ ๊ธฐ๋ฐ˜ ์ถ”์ฒœ ๋ถ„์„

1,761,675
์ด ์„ธ์…˜ ์ˆ˜
1.6
ํ‰๊ท  ์„ธ์…˜ ๊ธธ์ด
1.3
์„ธ์…˜๋‹น ํ‰๊ท  ๊ณ ์œ  ์•„์ดํ…œ

๐Ÿ”„ ์„ธ์…˜ ํŒจํ„ด ๋ถ„ํฌ

view_only: 1,715,386๊ฐœ ์„ธ์…˜ (97.37%)
cart_only: 31,992๊ฐœ ์„ธ์…˜ (1.82%)
conversion: 14,297๊ฐœ ์„ธ์…˜ (0.81%)

๐Ÿ“Š 6. ์ƒ์„ธ ๋ถ„์„ ๊ฒฐ๊ณผ

==================================================
1. ๋ฐ์ดํ„ฐ ๊ธฐ๋ณธ ๊ตฌ์กฐ ํŒŒ์•…
==================================================

EVENTS
   Shape: (2756101, ['timestamp', 'visitorid', 'event', 'itemid', 'transactionid'])
   Memory: 234.77 MB
   Columns: ['timestamp', 'visitorid', 'event', 'itemid', 'transactionid']

ITEM_PROPERTIES
   Shape: (20275902, ['timestamp', 'itemid', 'property', 'value'])
   Memory: 2743.19 MB
   Columns: ['timestamp', 'itemid', 'property', 'value']

CATEGORY_TREE
   Shape: (1669, ['categoryid', 'parentid'])
   Memory: 0.03 MB
   Columns: ['categoryid', 'parentid']

==================================================
2. ์ด๋ฒคํŠธ ๋กœ๊ทธ ๋ถ„์„
==================================================

์ด๋ฒคํŠธ ํƒ€์ž… ๋ถ„ํฌ:
view: 2,664,312
addtocart: 69,332
transaction: 22,457

์ „ํ™˜ ํผ๋„:
   View โ†’ AddToCart: 2.60%
   AddToCart โ†’ Transaction: 32.39%
   View โ†’ Transaction: 0.84%

์‚ฌ์šฉ์ž ํ–‰๋™ ์ˆ˜์ค€:
   ๊ณ ์œ  ๋ฐฉ๋ฌธ์ž ์ˆ˜: 1,407,580
   ์ด ์ด๋ฒคํŠธ ์ˆ˜: 2,756,101
   ๋ฐฉ๋ฌธ์ž๋‹น ํ‰๊ท  ์ด๋ฒคํŠธ ์ˆ˜: 1.96

==================================================
3. ์‚ฌ์šฉ์ž ํ–‰๋™ ํŒจํ„ด ๋ถ„์„
==================================================

์‚ฌ์šฉ์ž ์œ ํ˜• ๋ถ„ํฌ:
   browser: 1,368,715 (97.24%)
   cart_user: 27,146 (1.93%)
   buyer: 11,719 (0.83%)

์นดํ…Œ๊ณ ๋ฆฌ ์„ ํ˜ธ๋„๊ฐ€ ์žˆ๋Š” ์‚ฌ์šฉ์ž: 1,236,032

==================================================
4. ์•„์ดํ…œ ์œ ์‚ฌ๋„ ํŠน์„ฑ ๋ถ„์„
==================================================

๋ถ„์„๋œ ์•„์ดํ…œ ์ˆ˜: 449,240
์นดํ…Œ๊ณ ๋ฆฌ๊ฐ€ ์žˆ๋Š” ์•„์ดํ…œ: 399,425

์ƒ์œ„ 10๊ฐœ ์ธ๊ธฐ ์•„์ดํ…œ:
 1. ์•„์ดํ…œ 461686: ์ธ๊ธฐ๋„ 4787.0, ์ „ํ™˜์œจ 5.24%
 2. ์•„์ดํ…œ 187946: ์ธ๊ธฐ๋„ 3416.0, ์ „ํ™˜์œจ 0.00%
 3. ์•„์ดํ…œ 5411: ์ธ๊ธฐ๋„ 2352.0, ์ „ํ™˜์œจ 0.00%
 4. ์•„์ดํ…œ 7943: ์ธ๊ธฐ๋„ 2097.0, ์ „ํ™˜์œจ 3.42%
 5. ์•„์ดํ…œ 320130: ์ธ๊ธฐ๋„ 2086.0, ์ „ํ™˜์œจ 2.48%
 6. ์•„์ดํ…œ 320130: ์ธ๊ธฐ๋„ 2086.0, ์ „ํ™˜์œจ 2.48%
 7. ์•„์ดํ…œ 320130: ์ธ๊ธฐ๋„ 2086.0, ์ „ํ™˜์œจ 2.48%
 8. ์•„์ดํ…œ 320130: ์ธ๊ธฐ๋„ 2086.0, ์ „ํ™˜์œจ 2.48%
 9. ์•„์ดํ…œ 320130: ์ธ๊ธฐ๋„ 2086.0, ์ „ํ™˜์œจ 2.48%
10. ์•„์ดํ…œ 320130: ์ธ๊ธฐ๋„ 2086.0, ์ „ํ™˜์œจ 2.48%

==================================================
5. ์„ธ์…˜ ๊ธฐ๋ฐ˜ ์ถ”์ฒœ ๋ถ„์„
==================================================

์„ธ์…˜ ํ†ต๊ณ„:
   ์ด ์„ธ์…˜ ์ˆ˜: 1,761,675
   ํ‰๊ท  ์„ธ์…˜ ๊ธธ์ด: 1.56 ์ด๋ฒคํŠธ
   ํ‰๊ท  ์„ธ์…˜ ์‹œ๊ฐ„: 1.75 ๋ถ„
   ํ‰๊ท  ์„ธ์…˜๋‹น ๊ณ ์œ  ์•„์ดํ…œ: 1.33

์„ธ์…˜ ํŒจํ„ด ๋ถ„ํฌ:
   view_only: 1,715,386 (97.37%)
   cart_only: 31,992 (1.82%)
   conversion: 14,297 (0.81%)

==================================================
6. ์ด์ƒ ์‚ฌ์šฉ์ž ํƒ์ง€
==================================================

์ด์ƒ์น˜ ํƒ์ง€ ๊ฒฐ๊ณผ:
   ์ด ์‚ฌ์šฉ์ž ์ˆ˜: 1,407,580
   ์ด์ƒ์น˜ ์‚ฌ์šฉ์ž ์ˆ˜: 301,101
   ์ด์ƒ์น˜ ๋น„์œจ: 21.39%

๐Ÿ“ˆ 7. ํ†ตํ•ฉ ์‹œ๊ฐํ™”

์ถ”์ฒœ ์‹œ์Šคํ…œ ๋ถ„์„ ์‹œ๊ฐํ™”

๐Ÿ“Š ์‹œ๊ฐํ™” ์„ค๋ช…:
โ€ข ์ด๋ฒคํŠธ ํƒ€์ž… ๋ถ„ํฌ: ์‚ฌ์šฉ์ž ํ–‰๋™ ์œ ํ˜•๋ณ„ ๋น„์œจ (view, addtocart, transaction)
โ€ข ์‚ฌ์šฉ์ž ์œ ํ˜• ๋ถ„ํฌ: ํ–‰๋™ ํŒจํ„ด์— ๋”ฐ๋ฅธ ์‚ฌ์šฉ์ž ๋ถ„๋ฅ˜ (browser, cart_user, buyer)
โ€ข ์‹œ๊ฐ„๋Œ€๋ณ„ ์ด๋ฒคํŠธ ๋ถ„ํฌ: ํ•˜๋ฃจ ์ค‘ ์‚ฌ์šฉ์ž ํ™œ๋™์ด ๊ฐ€์žฅ ํ™œ๋ฐœํ•œ ์‹œ๊ฐ„๋Œ€ ํŒŒ์•…
โ€ข ์•„์ดํ…œ ์ธ๊ธฐ๋„ ๋ถ„ํฌ: ์ƒํ’ˆ๋ณ„ ์กฐํšŒ์ˆ˜ ๋ถ„ํฌ (๋กœ๊ทธ ์Šค์ผ€์ผ๋กœ Long-tail ํ˜„์ƒ ํ™•์ธ)
โ€ข ์ „ํ™˜ ํผ๋„: View โ†’ AddToCart โ†’ Transaction ๋‹จ๊ณ„๋ณ„ ์ „ํ™˜์œจ
โ€ข ์„ธ์…˜ ํŒจํ„ด ๋ถ„ํฌ: ์„ธ์…˜๋ณ„ ํ–‰๋™ ํŒจํ„ด ์œ ํ˜• (view_only, cart_only, conversion)
โ€ข ์นดํ…Œ๊ณ ๋ฆฌ๋ณ„ ์ด๋ฒคํŠธ ์ˆ˜: ๊ฐ€์žฅ ์ธ๊ธฐ ์žˆ๋Š” ์ƒํ’ˆ ์นดํ…Œ๊ณ ๋ฆฌ Top 20
โ€ข ์„ธ์…˜ ๊ธธ์ด๋ณ„ ์ „ํ™˜์œจ: ์„ธ์…˜ ๊ธธ์ด์— ๋”ฐ๋ฅธ ๊ตฌ๋งค ์ „ํ™˜์œจ ๋ณ€ํ™” ์ถ”์ด

๐ŸŒณ 8. ์นดํ…Œ๊ณ ๋ฆฌ ํŠธ๋ฆฌ ๋„คํŠธ์›Œํฌ

์ „์ฒด ์นดํ…Œ๊ณ ๋ฆฌ ๊ณ„์ธต ๊ตฌ์กฐ

๐ŸŒณ ์นดํ…Œ๊ณ ๋ฆฌ ํŠธ๋ฆฌ ์„ค๋ช…:
โ€ข ๋…ธ๋“œ ํ•„ํ„ฐ๋ง: ์—ฐ๊ฒฐ์ด ๋งŽ์€ ์ฃผ์š” ์นดํ…Œ๊ณ ๋ฆฌ๋“ค๋งŒ ํ‘œ์‹œ
โ€ข ๋ผ๋ฒจ ์ตœ์ ํ™”: ์—ฐ๊ฒฐ์ด ๋งŽ์€ ๋…ธ๋“œ(5๊ฐœ ์ด์ƒ)๋งŒ ๋ผ๋ฒจ ํ‘œ์‹œํ•˜์—ฌ ํ…์ŠคํŠธ ๊ฒน์นจ ๋ฐฉ์ง€
โ€ข ์ƒ‰์ƒ ๊ฐœ์„ : Viridis ์ƒ‰์ƒ ์Šค์ผ€์ผ๋กœ ์—ฐ๊ฒฐ ์ˆ˜์— ๋”ฐ๋ฅธ ์ƒ‰์ƒ ๊ตฌ๋ถ„
โ€ข ํฌ๊ธฐ ์กฐ์ •: ์—ฐ๊ฒฐ ์ˆ˜์— ๋”ฐ๋ผ ๋…ธ๋“œ ํฌ๊ธฐ๊ฐ€ ๋™์ ์œผ๋กœ ์กฐ์ • (8-25px ๋ฒ”์œ„)
โ€ข ์—ฃ์ง€ ํˆฌ๋ช…๋„: ์–‡๊ณ  ํˆฌ๋ช…ํ•œ ์—ฃ์ง€๋กœ ์‹œ๊ฐ์  ๋ณต์žก์„ฑ ๊ฐ์†Œ
โ€ข ํ˜ธ๋ฒ„ ์ •๋ณด: ๊ฐ ์นดํ…Œ๊ณ ๋ฆฌ์˜ ์ž์‹/๋ถ€๋ชจ ์นดํ…Œ๊ณ ๋ฆฌ ์ˆ˜์™€ ์ด ์—ฐ๊ฒฐ ์ˆ˜ ํ‘œ์‹œ
โ€ข ์ถ”์ฒœ ํ™œ์šฉ: ์นดํ…Œ๊ณ ๋ฆฌ ๊ธฐ๋ฐ˜ ์ถ”์ฒœ ์‹œ์Šคํ…œ์—์„œ ์ƒ์œ„/ํ•˜์œ„ ์นดํ…Œ๊ณ ๋ฆฌ ๊ด€๊ณ„ ํŒŒ์•…์— ํ™œ์šฉ

๐Ÿ“Š ๋ฆฌํฌํŠธ ์ƒ์„ฑ ์‹œ๊ฐ„: 2025-10-29 08:39:47

๐Ÿ” ๋ถ„์„ ๋„๊ตฌ: Python, Pandas, Plotly